Covid-19 Impacts Analysis using Python

The Covid-19 pandemic has had a significant impact on virtually every aspect of our lives, from health and economics to social norms and personal relationships. Almost all the countries were impacted negatively by the rise in the cases of Covid- 19.

The first wave of Covid- 19 impacted Global Economic, Health, Education, Politics, environments as the world was never ready for the pandemic. It resulted in a rise in cases, a rise in deaths, a rise in unemployment and a rise in povetry.

This project covers the analysis of the spread of Covid-19 cases and all the impacts of covid-19 on the economy.

Data soource: Kaggle (https://www.kaggle.com/datasets/shashwatwork/impact-of-covid19-pandemic-on-the-global-economy?resource=download)

The data has the following attributes;

Importing Covid-19 datasets

we have 50418 rows and 9 columns. It contains the data on covid-19 cases and their impact on GDP from December 31, 2019, to October 10, 2020.

Data Preparation

there are two data files, Using both the dataset for this analysis, because they both contain equally vital information in different columns.

After having first views of the datasets, there is a need to consolidate both datasets by created a new dataset.

Checking counts of countries available in the dataset.

We can say countries like Afghannistan, Indonesia, Maceconia, Luxembourg, Lithuania recorded high number of cases. But wanna confirm by getting the mode.

I was right with 294 as the mode value. Gonna use it to divide the sum of all the smaples related to the human development index, GDP per capital, and the pupolation.

merging the two datasets, by combining necessary columns from both datasets.

Note: GDP per capital is not included in the column yet. No correct figures for it in the dataset. Probally, it will be better to compute the GDP per capital manually for the countries. But doing that for all the countries will be time consuming, so, selecting a subsmaple from the dataset by selecting the top 10 countries with the highest number of covid-19 cases.

Top 10 Countries with highest Covis-19 Cases

Adding two more columns; GDP per capital before pandemic, and during covid-19 pandemic.

Note; The data about the GDP per Capital is inputted manually. Data source is online
Info Graph Analysis of the spread of Covid-19

Basically, doing my analysis on the selected countries with highest number of recorded cases. so, visualizing the countries.

Decided to use of Plotly tool for my visualization instead of seaborn and matplotlib

From the data, I can see that USA is having a highnumber of recorded covid-19 cases as compared to the rest of the countries.While UK, Columbia have the least number of covid-19 cases among the top 10 countries selected.

Now looking at the total number of dealths among the countries with the highest number of dealths among the top 10 countries with the highest number of covid-19 cases

USA still leading in the deaths recorded, with Brazil and India in the second and third positions. One thing to notice here is that the death rate in India, Russia, and South Africa is correlating according to the total number of cases observed on the above chart.

Plotting the total number of cases and total dealths in all these countries together for comparison.

This can lead us to a question that, what happened in Inida, russia and south Africa to have high number of cases but low dealth rates.

This brought up a question to know the percentage of total deaths and total cases among all the countries with highest number covid-19 cases

There was only 3.49% of total deaths with 96.5% total cases.

Death rate of Covid-19 cases can be calculated manually below;

Stringency index, talks about response indicators measurement. Including schood closures, workplace closures, and travel bans. It measures how the countries followed these precautions to control the spread of Covid-19

This shows India performed well in the taken strictly measure to avoid the spread of covid-19. It has the highest stringency index of 3.6

Analyzing the Impacts on Global Economy.

As GDP per capital is the only primary factor for analyzing the economic retrogression caused due to the covid-19 pandemic. Visually analyzing GDp before and during the outbreak among the countries selected.

checking for GDP per capital during the outbreak;

Overlaying Before and during GPD per capital to see their differences. to have a look at the impact of covid-19.

It's definitely obvious that, GDP per capital dropped in all the countries with the highest number of covid-19 cases.

Another economic factor is Human Development Index

It is a statistic composite index of life expectancy, education, and per capita indicators. Let’s have a look at how many countries were spending their budget on the human development:

This shows that USA and Uk spent their budgets more on the human development than other countries.

Conclusion

The Covid-19 pandemic has affected almost all countries in the world, with varying degrees of severity. The total number of cases and deaths are correlated, suggesting that countries with higher cases are likely to have higher deaths as well. The stringency index of a country, which measures the strictness of Covid-19 control measures, is negatively correlated with the number of cases and deaths, suggesting that stricter measures have been effective in reducing the spread of the virus.The outbreak of covid-19 resulted in the highest number of covid-19 cases and deaths in the united states. One major reason behind this is the stringency index of the United States. It is comparatively low according to the population. All the countries GDP per capital were affected during the outbreak of covid-19.

Recommendations